DECLARE @ApplicationName nvarchar(max) = 'WASM'
DECLARE @ApplicationId nvarchar(max) = 'D96D6A73-A171-41A3-97D3-54A413DC12D7'
DECLARE @currentTime datetime = GETDATE()


DECLARE @AdministratorRole nvarchar(max) = 'Administrator'
DECLARE @UserRole nvarchar(max) = 'User'

DECLARE @User_UserName nvarchar(max) = 'user'
DECLARE @User_UserPassword nvarchar(max) = 'user'
DECLARE @User_UserId uniqueidentifier

DECLARE @Administrator_UserName nvarchar(max) = 'admin'
DECLARE @Administrator_UserPassword nvarchar(max) = 'admin'
DECLARE @Administrator_UserId uniqueidentifier

exec aspnet_Applications_CreateApplication @ApplicationName, @ApplicationId

exec aspnet_Roles_CreateRole @ApplicationName, @AdministratorRole
exec aspnet_Roles_CreateRole @ApplicationName, @UserRole

exec aspnet_Membership_CreateUser  @ApplicationName, @User_UserName, @Administrator_UserPassword, '', 'test@tut.by', NULL, NULL, 1, @currentTime, @currentTime, 0, 0, @User_UserId OUTPUT
EXEC aspnet_UsersInRoles_AddUsersToRoles @ApplicationName, @User_UserName, @UserRole, @currentTime

exec aspnet_Membership_CreateUser  @ApplicationName, @Administrator_UserName, @Administrator_UserPassword, '', 'test@tut.by', NULL, NULL, 1, @currentTime, @currentTime, 0, 0, @Administrator_UserId OUTPUT
exec aspnet_UsersInRoles_AddUsersToRoles @ApplicationName, @Administrator_UserName, @AdministratorRole, @currentTime
